/***********************************************************
* Purpose : Get Prize_Format by ID
* Author : DATDT
* Date: 25/3/2012
* Description: Get Prize_Format by ID
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_GetPrize_FormatbyID') 
BEGIN
	DROP PROC sp_GetPrize_FormatbyID
END
GO
CREATE PROC sp_GetPrize_FormatbyID
	@ID INT
AS
BEGIN
	SELECT * FROM Prize_Format where ID = @ID
END